IF exists(SELECT * FROM dbo.sysobjects WHERE name='ebrussel_aantallen' AND xtype='V') 
BEGIN
	DROP VIEW ebrussel_aantallen
END
GO

create view ebrussel_aantallen
as

select keuzeVm,' ' as keuzeNM ,count(keuzeVM) as VMaantal,' ' as NMaantal
from 
ebrussel_overzicht
group by keuzeVM

union

select ' ' as keuzeVM,keuzeNm,' ' as VMaantal,count(keuzeNM) as NMaantal
from 
ebrussel_overzicht
group by keuzeNM